Project Summary
Data exploration and Analysis has been done in Mysql
I have provided a database of six tables containing all the details about the company's consumer goods.
It showcases the product details, sales details, prices, and customer information.
I have analyzed various insights through this project, such as
1. Markets in which Atliq Exclusive customers have businesses in the APAC region,
2. Unique product increases in the fiscal years of 2020 and 2021,
3. The highest and lowest manufacturing costs for the products,
4. The top five customers who bought the highest pre-invoice discounts,
5. The gross sales amount for Atliq Exclusive customers for each month in 2020 and 2021,
6. The top three products in each division
Additionally, I have identified trends in the data that can be used to inform future decisions.
Looking at the data from Fiscal years 2020 and 2021, it's clear that the company had better growth in 2021 than in 2020. This is likely due to the Covid-19 pandemic. Otherwise, every month has seen a decent and similar level of revenue.
To continue this growth, we should focus on increasing customer and consumer satisfaction. This will automatically improve our revenue. Another way to increase our profit margin is to reduce the percentage of pre-invoice discounts.
Let's see the project and explore all its objectives and insights.
Power BI Report :